package com.whz.workmanageol.dao;


import com.whz.workmanageol.entity.Course;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;


import java.util.List;

@Repository
public interface CourseMapper extends Mapper<Course> {
    @Select("select id from course where coursename = #{coursename}")
    String findIDByCoursename(String coursename);

    List<Course> findCourseByGradeid(String gradeid);

    List<Course> findCourseByTeacherid(String teacherid);

    List<Course> findCourseByGradeIdAndTeacherId(@Param("gradeId") String gradeId, @Param("teacherId") String teacherId);
}
